<?
//<meta http-equiv="content-type" content="text/html; charset=utf-8">
include "head.php";
?>
<p><a href="index.php">HOME</a> / <a href="setup.php">Setup</a> / <strong>Meta Thesaurus </strong></p>
<p><u>Tables</u></p>
<table border="0" cellpadding="3" cellspacing="1" class="simple_table">
  <tr>
    <td valign=top>FIL</td>
    <td valign=top>DES</td>
    <td valign=top>FMT</td>
    <td valign=top>CLS</td>
    <td valign=top>RWS</td>
    <td valign=top>BTS</td>
  </tr>
<?
$query = "select * from MRFILES";
$result = mysql_query($query) or die("\n<br>Query:$query\n<br>Error:".mysql_error());
while( $row = mysql_fetch_array($result) ) {
	$fil = $row['FIL'];
	$table_name = substr($fil, 0, strlen($fil)-4);
	$print_fmt = str_replace(",", ", ", $row['FMT']);
	
	if ( substr($table_name, 0, 4) == "MRXW" && $table_name != "MRXW_ENG" ) continue;
	if ( substr($table_name, 0, 6) == "CHANGE" ) continue;
?>
  <tr>
    <td valign=top><a href="search_thesaurus.php?table_name=<?=$table_name?>"><?=$table_name?></a>
	</td>
    <td valign=top><?=$row['DES']?></td>
    <td valign=top><?=$print_fmt?></td>
    <td valign=top><?=$row['CLS']?></td>
    <td valign=top align="right"><?=number_format($row['RWS'], 0, '.', ",")?></td>
    <td valign=top align="right"><?=number_format($row['BTS'], 0, '.', ",")?></td>
  </tr>
<?
}
?>
</table>
<p>&nbsp;</p>
<?
include "tail.php";
?>